ODI Tool for Huge Data
We use this Data Integrator tool to handle ETL(Extract, Transform and Load) part of large volume of data to fulfil our stakeholder …
Overview
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Connect to traditional data sources (11)9.999%
- Complex transformations (11)9.999%
- Simple transformations (11)9.999%
- Business rules and workflow (11)9.191%
Pricing
N/A
Unavailable
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
10 people also want pricing
Alternatives Pricing
N/A
Unavailable
What is SolarWinds Task Factory?
According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…
What is Dataloader.io?
Dataloader.io delivers a cloud based solution to import and export information from Salesforce.
Product Demos
Oracle Data Integrator(ODI)|| Oracle Data Integrator Strategy
YouTube
Oracle Data Integrator(ODI) || ODI XML to DataBase Part-1
YouTube
Oracle Data Integrator(ODI) demo video | ODI Tutorials
YouTube
Oracle Data Integrator(ODI)|| ODI Interview questions
YouTube
ODI INTRODUCTION Demo: RR ITEC, Hyderabad, India
YouTube
Oracle Data Integrator(ODI) || Introduction
YouTube
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator offers Bulk Data Movement and Data Transformation. It offers extract load and transform (ELT) technology that operates even across heterogeneous systems.
Features include :
Features include :
-ELT architecture
-Heterogeneous platform support for enterprise data integration
-Knowledge modules for optimized developer productivity and extensibility
-Service-oriented data integration and management for SOA environments
Oracle Data Integrator (ODI) Video
What is Oracle Data Integrator?
Oracle Data Integrator (ODI) Competitors
Oracle Data Integrator (ODI) Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
IBM InfoSphere Information Server, Talend Data Fabric, and Informatica Cloud Data Integration are common alternatives for Oracle Data Integrator (ODI).
Reviewers rate Connect to traditional data sources and Simple transformations and Complex transformations highest, with a score of 9.9.
The most common users of Oracle Data Integrator (ODI) are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(125)Attribute Ratings
Reviews
(1-15 of 15)Companies can't remove reviews or game the system. Here's why
June 04, 2021
ODI Tool for Huge Data
We use this Data Integrator tool to handle ETL(Extract, Transform and Load) part of large volume of data to fulfil our stakeholder requirements. This tool does a really great job to handle good amount of data from various sources and maintain the business intelligence system. This tool is being used in specific departments for now.
- The User Interface is pretty neat and clean which is very easy to use.
- There are a lot of transformation options available to choose from.
- The scalability and performance are top notch.
- The cost part is bit high as compared to its peers.
- Sometimes there is a lag and it gets hanged.
- Real time data Integration cannot be handled.
December 14, 2020
Oracle Data Integrator delivers for our company!
Currently, ODI is used within a few departments of our organization. We utilize it with other Oracle Utility Applications and Middleware (SOA) as an ETL tool. We have a number of interfaces linked with our Oracle Databases and the ODI layer is used to do transformations. We also use it as part of Oracle Utility Analytics with their extractors and it is integrated with part of our GoldenGate Setup.
- Integration with other Oracle products.
- Install/documentation was easy to understand for interfaces/utility use.
- Consistent results, does what we need it to do.
- Oracle Support is not always the quickest to resolve ODI issues.
- Specifically with the OUA extractors, the install/documentation was lacking.
December 09, 2020
An Amazing ETL Tool!
As a number of our back end databases are Oracle based, so an ETL tool was required to handle all the data pipelining. Earlier it was being done through PL/SQL which was bit complex to learn for everyone. So it was decided to use Oracle Data Integrator as a formal ETL Tool. This is being used in specific departments as of now. This is an amazing tool to implement different transformation logics in an easier way and is quite efficient in handling the data which ends up in saving user's time.
- It is very easy to integrate with Oracle data sources at backend.
- Plenty of transformation options and reverse engineering is bit easier.
- The interface is very simple and user friendly.
- Real time integration is bit of a hassle.
- Customer Support could be improved to some extent.
- Data ingestion with variety of data sources could be difficult to implement.
December 04, 2020
Oracle Data Integrator is great for any ETL use cases
There are many products that do extract, transform, and load on data sets. It is a core task for any data engineer or data analyst. Alongside Oracle Cloud, we use Oracle Data Integrator to run ETL processes on our data. We use it widely to maintain our business intelligence systems.
- High-volume, batch load ETL processes
- Data transformations before data warehousing
- Flexible big-data extractions
- More easily used in other clouds/platforms
- More features in UI
- Updated flow of ETL processes in UI
December 04, 2020
Oracle Data Integrator--a great tool for Oracle users
Oracle Data Integrator is a very good ETL tool that can be used for many different business cases. We currently use it as an ETL application that ties into many of our backend systems. It helps us connect with many systems with the great integrations it has and gives us the ability to closely tie our data together. We use this for our data teams currently which then gets used for reports, etc. to make workflow and processes more streamlined.
- It is well integrated within the Oracle ecosystem
- Great product for data cleansing and virtualization
- Can have everything done in one tool in most cases
- It has great scalability/performance
- Oracle support is not the best when needing help with the system
- The documentation is also very poor and takes very long to generate
- Some parts of it are not intuitive to use and get hard to troubleshoot
- Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
- Like all Oracle products, cost is high
May 25, 2020
Easily integrates data, but could perform better
We often work with Oracle database products and Oracle Data Integrator has been really useful for EPMA integration. It allows us to have a vivid understanding of topological data. It helps us clarify loose ends as it concerns the plotting of data modules. It provides a significant improvement in clarity that helps us identify issues at job locations. It has been really helpful in visualizing the data set and centralizing company data.
- With Oracle Data Integrator, we get platform independence as it supports a wide range of platforms.
- The FCP makes it easy to administer infrastructure and visualize data flows.
- It is cost-effective.
- I think it still has a lot of work to do in terms of speed of access and operation. That is why it rates a "7 out of 10" for me.
- The quality of support can also be improved.
- It can take longer than usual to generate documentation.
- Generated code can also be complicated even for technical users.
February 28, 2020
Oracle Data Integrator review
Oracle Data Integrator is used in enterprise projects designed for data warehouse and ETL. It makes sense for us to use the ODI ETL product, especially since the databases we work with are usually oracle products. You can create individual ETL packages with the Oracle Data Integrator ETL product. You can schedule these ETL packets at certain time intervals. You can generate summary tables using aggregate functions in an Oracle Data Integrator product. In this way, you can create data march tables to be used in the data warehouse. The end-user interface of the Oracle Data Integrator product has an intricate appearance. The ETL design screen needs to be more straightforward and more user-friendly. Also, connections to databases other than Oracle can fail after certain periods of time.
- There are enough aggregate functions to design a Data Warehouse. In this way, summary tables can be created.
- Works compatible with Oracle databases. By making ODBC connections, database connections are made more stable.
- The end user interface of Oracle Data Integrator ETL can be made simpler and more convenient.
- Oracle external database connections are time out after a certain period of time. Therefore, data transfers can be disrupted.
October 25, 2019
Oracle Data Integrator enthusiast!
Oracle Data Integrator (ODI)is probably the best ETL tool in the market. We use it in order to integrate data from several different sources (mainly Oracle and SQL Server) and load the processed data into our Data Warehouse, applying some basic data quality rules (not the main function of ODI, but it has some small data quality features).
- Complex transformations.
- Compatibility with almost any knows valid source.
- Suited for batch loading processes.
- Small bugs related to Java.
- The user interface is not intuitive.
- The complexity of the tool makes difficult to find qualified people in the market.
- Expensive.
September 18, 2019
ODI User Review
I think that Oracle Data Integrator is effective in terms of keeping a database of financial information and it is also helpful since it connects with financial tools such as Hyperion. I utilize Hyperion to pull data from Oracle Data Integrator and use that as a leverage to build a company's financial projections. However, I think one big issue is that it can be quite slow during busy times. I think speed is one of the most essential things for the monthly close process.
- They connect to financial tools such as Hyperion.
- Holds financial data very well and easily retrieved when needed.
- All the support teams are very helpful and there when you need them
- Speed can sometimes be very slow.
- You need many technical support individuals to maintain.
- N/A
September 18, 2019
Heterogeneous Technologies in play with Oracle Data Integrator
It's used in critical integration projects to address the problems of integrating with multiple formats of various sources. We are able to debug at different log levels. It's easy to reuse components and it's helped in avoidance of any hard coding. It's easy to develop, maintain, configure and secure. We have the ability to call scripts,. The PL/SQL routines along with its regular mappings helped to avoid use of multiple tools.
- Leveraging the abilities of Target Database for transformations and computation
- Unique ability to integrate with heterogeneous sources works well.
- An application developer does not need to worry much about error handling like pl/SQL Developers have to do
- Need improvements in ease of access to the user interface
- Need to worry about whether all the required jar files are available or not for any new connection of any new technology.
- Each new technology has its own approach to establish the connectivity from ODI. Needs a seamless connectivity.
- Often ODI Repository throws errors for various reasons and a restart of the jobs will fix the issue automatically. But it could be avoided in first place. Like PK Violation on ODI Variables.
- ODI Agent time out errors. Need more work on High Availability. J2EE agents also fail to provide High Availability sometimes. Need a solution where at least one agent always works and balances connections on any intermittent network failures.
November 21, 2016
Oracle Data Integrator - The real data integrator
Oracle Data Integrator (ODI)is a powerful ETL tool. We use this across the organization to integrate data from various sources (mainly Peoplesoft) and load the processed data into Oracle Data Warehouse. The Data Warehouse loaded by ODI acts as a single source of truth for every department within the organization. All the department's raw data is pulled by ODI and processed before loading into Data Warehouse. Though this is a backend tool, which many front end users are not aware of its existence, it does a great job integrating data from different sources.
- Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
- Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
- Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
- The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
- The Java framework does not stand up to the mark. It crashes frequently. There is a long [list] of improvements required in terms of client tools framework.
- Though Oracle Data Integrator lets people login from a web browser to monitor different activities, it crashes and performs very poorly when logged in out of network. Even Oracle Data Integrator client tools don't perform well on a remote desktop. Increasing Java buffer is one of the workarounds, that might work. So, a better client tools and interface is a big advantage.
- Navigation is another pain area. It is very difficult to find out the precise error, in case of a failure, in Oracle Data Integrator. In Informatica, it is a cake walk to pull out a session log that shows up the exact reason for failure. Although Oracle Data Integrator is tightly integrated to database, it is very poor in providing the exact error at high level. One has to dig through to get it.
August 03, 2016
Oracle Data Integrator - Complex tool for Data Movement
Oracle Data Integrator is being used to move meta data from our repository that sits in SQL Server to the Hyperion Planning application. It is being utilized by our Finance department and it allows them to use the planning application efficiently to create budget and forecast information for the current year.
- Has many different source and destination connectors
- Manages workflow for data movement
- Many options in the data transformation toolbox
- Error handling is quite complicated
- Very cumbersome user interface
- Too much complexity makes easy jobs harder to maintain
Oracle Data Integrator is used to extract data from various manufacturing machines, transform it into a usable form, and load it into a data warehouse for use by Oracle Business Intelligence reports. In this case, it was used to attempt a "real-time data warehousing solution," which is not necessarily its intended operation. Data was provided every hour, as required by the client. It was used across the whole organization to help with various decisions, including but not limited to manufacturing quality, resource tracking, accountability, and equipment usage.
- Oracle Data Integrator is a very powerful tool. The graphical user interface simplifies the generation of complex SQL statements which can be used to extract and transform large amounts of data.
- ODI allows users to structure and schedule packages of code. It allows you to combine data extraction and transformation sequences based on business area, relationships, or whichever design technique best suits your organization.
- ODI is able to provide detailed logging information and send out alerts via email, simplifying the process of monitoring and debugging issues.
- ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
- ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
- ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
December 14, 2015
ODI - not necessarily an enterprise solution, but good enough for smaller financial systems implementations
In my prior role, I primarily used ODI as the ETL tool to transform data from relational systems or flat files into Hyperion Essbase. It was also the extraction tool from Essbase to various data marts/warehouses. ODI was used to map multiple source files/tables together, transform the data appropriately to align with Essbase nomenclature/naming conventions. ODI was also used as a scheduling tool to kick off command-line utilities specific to the Hyperion toolset and to manage interdependent data processing jobs for a given organization.
- Transforms and loads large amounts of data (gigabyte and up).
- Stores complex transformation logic in an understandable way that is easily updated after the fact.
- Managed multiple ETL user groups/credentials to segment data availability and execution pathways.
- ODI has a very arduous process for migrating components from one environment to another. I've found it to be error prone unless migrating a full schema which is not always a viable option.
- ODI has no web-based administration panel, all admin tasks must be handled via hard install.
- The scheduler tool is difficult to initially set up and not intuitive to manage. Takes a while to stand up properly.
July 29, 2014
ODI Review
Oracle Data Integrator was used to pull the Oracle BPM data into data mart. It was being used across the whole organization. It pulled the data from various sources and pushed it to a single source with very complex transformations. Master and incremental data was being loaded into the data warehouse.
- Incremental data loads
- Complex Transformations
- Detailed documentation of LKM/IKM
- Troubleshooting of failed jobs
- More user friendly interface
- Hierarchy flattening transformations
- Integration issues with SAP HANA